﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="RestaurantList.aspx.vb" Inherits="Korean_Food.RestaurantList" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<p>
    <asp:GridView ID="GridView1" runat="server" AllowSorting="True" 
        AutoGenerateColumns="False" DataKeyNames="ID" 
        DataSourceID="RestaurantSqlDataSource1" Height="172px" Width="673px">
        <Columns>
            <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" 
                ReadOnly="True" SortExpression="ID" />
            <asp:BoundField DataField="Restaurant_Name" HeaderText="Restaurant_Name" 
                SortExpression="Restaurant_Name" />
            <asp:BoundField DataField="Phone_No" HeaderText="Phone_No" 
                SortExpression="Phone_No" />
            <asp:BoundField DataField="Average_Price" HeaderText="Average_Price" 
                SortExpression="Average_Price" />
            <asp:BoundField DataField="Michelin_Stars" HeaderText="Michelin_Stars" 
                SortExpression="Michelin_Stars" />
            <asp:ImageField DataAlternateTextField="Restaurant_Picture" 
                DataImageUrlField="Restaurant_Picture" HeaderText="Thumbnails">
                <ControlStyle CssClass="restaurantPicture" />
            </asp:ImageField>
            <asp:HyperLinkField DataNavigateUrlFields="Web_Site" 
                DataNavigateUrlFormatString="{0}" DataTextField="Restaurant_Name" 
                HeaderText="Website" />
            <asp:HyperLinkField DataNavigateUrlFields="Post Code" 
                DataNavigateUrlFormatString="http://maps.google.co.uk/maps?q={0}" 
                DataTextField="Post Code" HeaderText="Maps" />
            <asp:HyperLinkField DataNavigateUrlFields="ID" 
                DataNavigateUrlFormatString="Details.aspx?id={0}" 
                DataTextField="Restaurant_Name" HeaderText="Link" Text="Link" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="RestaurantSqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:RestaurantConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:RestaurantConnectionString.ProviderName %>" 
        SelectCommand="SELECT ID, [Restaurant Name] AS Restaurant_Name, [Web Site] AS Web_Site, [Phone No] AS Phone_No, [Restaurant Picture] AS Restaurant_Picture, [Average Price] AS Average_Price, [Michelin Stars] AS Michelin_Stars, [Post Code] FROM Restuarant">
    </asp:SqlDataSource>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
</asp:Content>
